SUPPORT / SAMPLES & SAS NOTES
Problem Note 41027: The SCD Type 2 Loader transformation fails or experiences performance problems
 |  |  |  |  |
When using a SCD Type 2 Loader transformation to load data into a relational database (RDBMS) or a SAS® Scalable Performance Data Server®, errors or performance problems can occur due to one or more of the following issues:
- Performance is compromised because indexes are not being created on temporary tables, even though the option Create an index on the temporary tables used to update the target table is set to Yes.
- The job fails because the code that is generated contains table references in the format schema.tablename instead of tablename when the target is an Oracle table.
- The job fails due to errors because the code attempts to create indexes on temporary tables after data is loaded, when indexes must be created prior to data load.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Integration Studio | Microsoft® Windows® for x64 | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista for x64 | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||